Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_HIER_CUSTOM_SORT

`ALL_OLAP2_HIER_CUSTOM_SORT` shows the sort order for level columns within hierarchies. Custom sorting information is optional.

Custom sorting information specifies how to sort the members of a hierarchy based on columns in the dimension table. The specific columns in the dimension tables may be the same as the key columns or may be related attribute columns.

Custom sorting can specify that the column be sorted in ascending or descending order, with nulls first or nulls last. Custom sorting can be applied at multiple levels of a dimension.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension.
`DIMENSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension.
`HIERARCHY_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the hierarchy.
`TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension table.
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension table.
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the column to be sorted.
`POSITION` | `NUMBER` | `NOT NULL` | Represents the position within a multi-column `SORT_POSITION`. In most cases, a single column represents `SORT_POSITION`, and the value of `POSITION` is 1.
`SORT_POSITION` | `NUMBER` | `NOT NULL` | Position within the sort order of the level to be sorted.
`SORT_ORDER` | `VARCHAR2(4)` | `NOT NULL` | Sort order. Can be either `Ascending` or `Descending`.
`NULL_ORDER` | `VARCHAR2(5)` | `NOT NULL` | Where to insert null values in the sort order. Can be either `Nulls First` or `Nulls Last`.